Imports¶
In [2]:
pip install plotly
Collecting plotly Downloading plotly-5.16.1-py2.py3-none-any.whl (15.6 MB) Requirement already satisfied: packaging in c:\users\92321\anaconda3\lib\site-packages (from plotly) (21.0) Collecting tenacity>=6.2.0 Downloading tenacity-8.2.3-py3-none-any.whl (24 kB) Requirement already satisfied: pyparsing>=2.0.2 in c:\users\92321\anaconda3\lib\site-packages (from packaging->plotly) (3.0.4) Installing collected packages: tenacity, plotly Successfully installed plotly-5.16.1 tenacity-8.2.3 Note: you may need to restart the kernel to use updated packages.
In [3]:
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
%matplotlib inline
import seaborn as sns
import plotly.express as px
from IPython.core.display import display, HTML
display(HTML("<style>.container {width:100% !important; }</style>"))
Read CSV¶
In [4]:
playstore = pd.read_csv("Google-Playstore.csv", encoding="utf-8")
Exploratory Analysis¶
In [5]:
playstore.head(10)
Out[5]:
| App Name | App Id | Category | Rating | Rating Count | Installs | Minimum Installs | Maximum Installs | Free | Price | ... | Developer Website | Developer Email | Released | Last Updated | Content Rating | Privacy Policy | Ad Supported | In App Purchases | Editors Choice | Scraped Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Gakondo | com.ishakwe.gakondo | Adventure | 0.0 | 0.0 | 10+ | 10.0 | 15 | True | 0.0 | ... | https://beniyizibyose.tk/#/ | jean21101999@gmail.com | Feb 26, 2020 | Feb 26, 2020 | Everyone | https://beniyizibyose.tk/projects/ | False | False | False | 2021-06-15 20:19:35 |
| 1 | Ampere Battery Info | com.webserveis.batteryinfo | Tools | 4.4 | 64.0 | 5,000+ | 5000.0 | 7662 | True | 0.0 | ... | https://webserveis.netlify.app/ | webserveis@gmail.com | May 21, 2020 | May 06, 2021 | Everyone | https://dev4phones.wordpress.com/licencia-de-uso/ | True | False | False | 2021-06-15 20:19:35 |
| 2 | Vibook | com.doantiepvien.crm | Productivity | 0.0 | 0.0 | 50+ | 50.0 | 58 | True | 0.0 | ... | NaN | vnacrewit@gmail.com | Aug 9, 2019 | Aug 19, 2019 | Everyone | https://www.vietnamairlines.com/vn/en/terms-an... | False | False | False | 2021-06-15 20:19:35 |
| 3 | Smart City Trichy Public Service Vehicles 17UC... | cst.stJoseph.ug17ucs548 | Communication | 5.0 | 5.0 | 10+ | 10.0 | 19 | True | 0.0 | ... | http://www.climatesmarttech.com/ | climatesmarttech2@gmail.com | Sep 10, 2018 | Oct 13, 2018 | Everyone | NaN | True | False | False | 2021-06-15 20:19:35 |
| 4 | GROW.me | com.horodyski.grower | Tools | 0.0 | 0.0 | 100+ | 100.0 | 478 | True | 0.0 | ... | http://www.horodyski.com.pl | rmilekhorodyski@gmail.com | Feb 21, 2020 | Nov 12, 2018 | Everyone | http://www.horodyski.com.pl | False | False | False | 2021-06-15 20:19:35 |
| 5 | IMOCCI | com.imocci | Social | 0.0 | 0.0 | 50+ | 50.0 | 89 | True | 0.0 | ... | http://www.imocci.com | info@imocci.com | Dec 24, 2018 | Dec 20, 2019 | Teen | https://www.imocci.com/wp-content/uploads/2018... | False | True | False | 2021-06-15 20:19:35 |
| 6 | unlimited 4G data prank free app | getfreedata.superfatiza.unlimitedjiodataprank | Libraries & Demo | 4.5 | 12.0 | 1,000+ | 1000.0 | 2567 | True | 0.0 | ... | NaN | aitomgharfatimezzahra@gmail.com | Sep 23, 2019 | Sep 27, 2019 | Everyone | https://sites.google.com/view/unlimited4gdatap... | True | False | False | 2021-06-15 20:19:35 |
| 7 | The Everyday Calendar | com.mozaix.simoneboard | Lifestyle | 2.0 | 39.0 | 500+ | 500.0 | 702 | True | 0.0 | ... | NaN | elementuser03@gmail.com | Jun 21, 2019 | Jun 21, 2019 | Everyone | https://www.freeprivacypolicy.com/privacy/view... | False | False | False | 2021-06-15 20:19:35 |
| 8 | WhatsOpen | com.whatsopen.app | Communication | 0.0 | 0.0 | 10+ | 10.0 | 18 | True | 0.0 | ... | http://yilvermolinah.com | yilver.mh1996@gmail.com | NaN | Dec 07, 2018 | Teen | http://elcafedelamanana.yilvermolinah.com/poli... | False | False | False | 2021-06-15 20:19:35 |
| 9 | Neon 3d Iron Tech Keyboard Theme | com.ikeyboard.theme.neon_3d.iron.tech | Personalization | 4.7 | 820.0 | 50,000+ | 50000.0 | 62433 | True | 0.0 | ... | https://trendyteme888-31139.web.app | trendyteme.888@gmail.com | Sep 22, 2019 | Oct 07, 2020 | Everyone | http://bit.ly/EmojiThemePro | True | False | False | 2021-06-15 20:19:35 |
10 rows × 24 columns
In [7]:
playstore.tail()
Out[7]:
| App Name | App Id | Category | Rating | Rating Count | Installs | Minimum Installs | Maximum Installs | Free | Price | ... | Developer Website | Developer Email | Released | Last Updated | Content Rating | Privacy Policy | Ad Supported | In App Purchases | Editors Choice | Scraped Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2312939 | 大俠客—熱血歸來 | com.rxsj.ssjj | Role Playing | 4.3 | 16775.0 | 100,000+ | 100000.0 | 337109 | True | 0.0 | ... | http://www.4399sy.com.hk/ | ssjjcomhk@gmail.com | NaN | Jun 01, 2021 | Teen | http://a.4399sy.com.hk/user/aggreement | False | False | False | 2021-06-16 12:59:18 |
| 2312940 | ORU Online | com.threedream.oruonline | Education | 0.0 | 0.0 | 100+ | 100.0 | 430 | True | 0.0 | ... | http://www.oru.edu/ | 3DreamDeveloper@gmail.com | Jan 17, 2018 | Feb 02, 2018 | Everyone | http://www.oru.edu/about-oru/privacy-policy.php | False | False | False | 2021-06-16 12:59:19 |
| 2312941 | Data Structure | datastructure.appoworld.datastucture | Education | 0.0 | 0.0 | 100+ | 100.0 | 202 | True | 0.0 | ... | NaN | appoworld.official@gmail.com | Aug 19, 2018 | Aug 19, 2018 | Everyone | https://appoworld.000webhostapp.com/datastruct... | False | False | False | 2021-06-16 12:59:19 |
| 2312942 | Devi Suktam | ishan.devi.suktam | Music & Audio | 3.5 | 8.0 | 1,000+ | 1000.0 | 2635 | True | 0.0 | ... | https://a70f78905.app-ads-txt.com | ruchisono@gmail.com | Aug 1, 2016 | May 05, 2021 | Everyone | https://docs.google.com/document/d/1x-9reZuLRX... | True | False | False | 2021-06-16 12:59:19 |
| 2312943 | Biliyor Musun - Sonsuz Yarış | com.yyazilim.biliyormusun | Trivia | 5.0 | 12.0 | 100+ | 100.0 | 354 | True | 0.0 | ... | NaN | yyazilimdevelop@gmail.com | Aug 9, 2019 | Aug 19, 2019 | Everyone | https://biliyor-musun-sons.flycricket.io/priva... | True | False | False | 2021-06-16 12:59:19 |
5 rows × 24 columns
In [8]:
playstore[['Currency',
'Size', 'Minimum Android', 'Developer Id']]
Out[8]:
| Currency | Size | Minimum Android | Developer Id | |
|---|---|---|---|---|
| 0 | USD | 10M | 7.1 and up | Jean Confident Irénée NIYIZIBYOSE |
| 1 | USD | 2.9M | 5.0 and up | Webserveis |
| 2 | USD | 3.7M | 4.0.3 and up | Cabin Crew |
| 3 | USD | 1.8M | 4.0.3 and up | Climate Smart Tech2 |
| 4 | USD | 6.2M | 4.1 and up | Rafal Milek-Horodyski |
| ... | ... | ... | ... | ... |
| 2312939 | USD | 77M | 4.1 and up | ALICE GAME |
| 2312940 | USD | 44M | 4.1 and up | 3Dream Studios, LLC |
| 2312941 | USD | 29M | 5.0 and up | appoworld |
| 2312942 | USD | 10M | 5.0 and up | Bhakti |
| 2312943 | USD | 5.2M | 5.0 and up | Y Yazılım |
2312944 rows × 4 columns
In [9]:
playstore.Category.unique()
Out[9]:
array(['Adventure', 'Tools', 'Productivity', 'Communication', 'Social',
'Libraries & Demo', 'Lifestyle', 'Personalization', 'Racing',
'Maps & Navigation', 'Travel & Local', 'Food & Drink',
'Books & Reference', 'Medical', 'Puzzle', 'Entertainment',
'Arcade', 'Auto & Vehicles', 'Photography', 'Health & Fitness',
'Education', 'Shopping', 'Board', 'Music & Audio', 'Sports',
'Beauty', 'Business', 'Educational', 'Finance', 'News & Magazines',
'Casual', 'Art & Design', 'House & Home', 'Card', 'Events',
'Trivia', 'Weather', 'Strategy', 'Word', 'Video Players & Editors',
'Action', 'Simulation', 'Music', 'Dating', 'Role Playing',
'Casino', 'Comics', 'Parenting'], dtype=object)
In [10]:
playstore.columns
Out[10]:
Index(['App Name', 'App Id', 'Category', 'Rating', 'Rating Count', 'Installs',
'Minimum Installs', 'Maximum Installs', 'Free', 'Price', 'Currency',
'Size', 'Minimum Android', 'Developer Id', 'Developer Website',
'Developer Email', 'Released', 'Last Updated', 'Content Rating',
'Privacy Policy', 'Ad Supported', 'In App Purchases', 'Editors Choice',
'Scraped Time'],
dtype='object')
In [11]:
playstore.info()
<class 'pandas.core.frame.DataFrame'> RangeIndex: 2312944 entries, 0 to 2312943 Data columns (total 24 columns): # Column Dtype --- ------ ----- 0 App Name object 1 App Id object 2 Category object 3 Rating float64 4 Rating Count float64 5 Installs object 6 Minimum Installs float64 7 Maximum Installs int64 8 Free bool 9 Price float64 10 Currency object 11 Size object 12 Minimum Android object 13 Developer Id object 14 Developer Website object 15 Developer Email object 16 Released object 17 Last Updated object 18 Content Rating object 19 Privacy Policy object 20 Ad Supported bool 21 In App Purchases bool 22 Editors Choice bool 23 Scraped Time object dtypes: bool(4), float64(4), int64(1), object(15) memory usage: 361.8+ MB
In [12]:
playstore.shape
Out[12]:
(2312944, 24)
In [13]:
playstore.describe()
Out[13]:
| Rating | Rating Count | Minimum Installs | Maximum Installs | Price | |
|---|---|---|---|---|---|
| count | 2.290061e+06 | 2.290061e+06 | 2.312837e+06 | 2.312944e+06 | 2.312944e+06 |
| mean | 2.203152e+00 | 2.864839e+03 | 1.834452e+05 | 3.202017e+05 | 1.034992e-01 |
| std | 2.106223e+00 | 2.121626e+05 | 1.513144e+07 | 2.355495e+07 | 2.633127e+00 |
| min | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 |
| 25% | 0.000000e+00 | 0.000000e+00 | 5.000000e+01 | 8.400000e+01 | 0.000000e+00 |
| 50% | 2.900000e+00 | 6.000000e+00 | 5.000000e+02 | 6.950000e+02 | 0.000000e+00 |
| 75% | 4.300000e+00 | 4.200000e+01 | 5.000000e+03 | 7.354000e+03 | 0.000000e+00 |
| max | 5.000000e+00 | 1.385576e+08 | 1.000000e+10 | 1.205763e+10 | 4.000000e+02 |
In [14]:
playstore.describe(include = "object")
Out[14]:
| App Name | App Id | Category | Installs | Currency | Size | Minimum Android | Developer Id | Developer Website | Developer Email | Released | Last Updated | Content Rating | Privacy Policy | Scraped Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 2312942 | 2312944 | 2312944 | 2312837 | 2312809 | 2312748 | 2306414 | 2312911 | 1552109 | 2312913 | 2241891 | 2312944 | 2312944 | 1891991 | 2312944 |
| unique | 2177944 | 2312944 | 48 | 22 | 15 | 1657 | 154 | 758371 | 810440 | 950456 | 4158 | 3918 | 6 | 977743 | 67374 |
| top | Tic Tac Toe | com.ishakwe.gakondo | Education | 100+ | USD | Varies with device | 4.1 and up | Subsplash Inc | http://www.subsplash.com/ | support@classplus.co | Jun 16, 2020 | Jun 10, 2021 | Everyone | http://www.subsplash.com/legal/privacy | 2021-06-16 07:35:57 |
| freq | 382 | 1 | 241090 | 443368 | 2311548 | 74777 | 604465 | 5422 | 7519 | 10345 | 2051 | 11186 | 2022089 | 7481 | 56 |
In [15]:
playstore.isna()
Out[15]:
| App Name | App Id | Category | Rating | Rating Count | Installs | Minimum Installs | Maximum Installs | Free | Price | ... | Developer Website | Developer Email | Released | Last Updated | Content Rating | Privacy Policy | Ad Supported | In App Purchases | Editors Choice | Scraped Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | False | False | False | False | False | False | False | False | False | False | ... | False | False | False | False | False | False | False | False | False | False |
| 1 | False | False | False | False | False | False | False | False | False | False | ... | False | False | False | False | False | False | False | False | False | False |
| 2 | False | False | False | False | False | False | False | False | False | False | ... | True | False | False | False | False | False | False | False | False | False |
| 3 | False | False | False | False | False | False | False | False | False | False | ... | False | False | False | False | False | True | False | False | False | False |
| 4 | False | False | False | False | False | False | False | False | False | False | ... | False | False | False | False | False | False | False | False | False | False |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2312939 | False | False | False | False | False | False | False | False | False | False | ... | False | False | True | False | False | False | False | False | False | False |
| 2312940 | False | False | False | False | False | False | False | False | False | False | ... | False | False | False | False | False | False | False | False | False | False |
| 2312941 | False | False | False | False | False | False | False | False | False | False | ... | True | False | False | False | False | False | False | False | False | False |
| 2312942 | False | False | False | False | False | False | False | False | False | False | ... | False | False | False | False | False | False | False | False | False | False |
| 2312943 | False | False | False | False | False | False | False | False | False | False | ... | True | False | False | False | False | False | False | False | False | False |
2312944 rows × 24 columns
In [16]:
na_counts = playstore.isna().sum()
na_counts = na_counts.to_frame().reset_index()
na_counts.columns = ["col", "count"]
na_counts
Out[16]:
| col | count | |
|---|---|---|
| 0 | App Name | 2 |
| 1 | App Id | 0 |
| 2 | Category | 0 |
| 3 | Rating | 22883 |
| 4 | Rating Count | 22883 |
| 5 | Installs | 107 |
| 6 | Minimum Installs | 107 |
| 7 | Maximum Installs | 0 |
| 8 | Free | 0 |
| 9 | Price | 0 |
| 10 | Currency | 135 |
| 11 | Size | 196 |
| 12 | Minimum Android | 6530 |
| 13 | Developer Id | 33 |
| 14 | Developer Website | 760835 |
| 15 | Developer Email | 31 |
| 16 | Released | 71053 |
| 17 | Last Updated | 0 |
| 18 | Content Rating | 0 |
| 19 | Privacy Policy | 420953 |
| 20 | Ad Supported | 0 |
| 21 | In App Purchases | 0 |
| 22 | Editors Choice | 0 |
| 23 | Scraped Time | 0 |
In [17]:
gp= playstore[['App Name', 'Rating', 'Rating Count', 'Installs',
'Minimum Installs', 'Currency', 'Size', 'Minimum Android', 'Developer Id', 'Developer Website',
'Developer Email', 'Released','Privacy Policy']]
gp
Out[17]:
| App Name | Rating | Rating Count | Installs | Minimum Installs | Currency | Size | Minimum Android | Developer Id | Developer Website | Developer Email | Released | Privacy Policy | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Gakondo | 0.0 | 0.0 | 10+ | 10.0 | USD | 10M | 7.1 and up | Jean Confident Irénée NIYIZIBYOSE | https://beniyizibyose.tk/#/ | jean21101999@gmail.com | Feb 26, 2020 | https://beniyizibyose.tk/projects/ |
| 1 | Ampere Battery Info | 4.4 | 64.0 | 5,000+ | 5000.0 | USD | 2.9M | 5.0 and up | Webserveis | https://webserveis.netlify.app/ | webserveis@gmail.com | May 21, 2020 | https://dev4phones.wordpress.com/licencia-de-uso/ |
| 2 | Vibook | 0.0 | 0.0 | 50+ | 50.0 | USD | 3.7M | 4.0.3 and up | Cabin Crew | NaN | vnacrewit@gmail.com | Aug 9, 2019 | https://www.vietnamairlines.com/vn/en/terms-an... |
| 3 | Smart City Trichy Public Service Vehicles 17UC... | 5.0 | 5.0 | 10+ | 10.0 | USD | 1.8M | 4.0.3 and up | Climate Smart Tech2 | http://www.climatesmarttech.com/ | climatesmarttech2@gmail.com | Sep 10, 2018 | NaN |
| 4 | GROW.me | 0.0 | 0.0 | 100+ | 100.0 | USD | 6.2M | 4.1 and up | Rafal Milek-Horodyski | http://www.horodyski.com.pl | rmilekhorodyski@gmail.com | Feb 21, 2020 | http://www.horodyski.com.pl |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2312939 | 大俠客—熱血歸來 | 4.3 | 16775.0 | 100,000+ | 100000.0 | USD | 77M | 4.1 and up | ALICE GAME | http://www.4399sy.com.hk/ | ssjjcomhk@gmail.com | NaN | http://a.4399sy.com.hk/user/aggreement |
| 2312940 | ORU Online | 0.0 | 0.0 | 100+ | 100.0 | USD | 44M | 4.1 and up | 3Dream Studios, LLC | http://www.oru.edu/ | 3DreamDeveloper@gmail.com | Jan 17, 2018 | http://www.oru.edu/about-oru/privacy-policy.php |
| 2312941 | Data Structure | 0.0 | 0.0 | 100+ | 100.0 | USD | 29M | 5.0 and up | appoworld | NaN | appoworld.official@gmail.com | Aug 19, 2018 | https://appoworld.000webhostapp.com/datastruct... |
| 2312942 | Devi Suktam | 3.5 | 8.0 | 1,000+ | 1000.0 | USD | 10M | 5.0 and up | Bhakti | https://a70f78905.app-ads-txt.com | ruchisono@gmail.com | Aug 1, 2016 | https://docs.google.com/document/d/1x-9reZuLRX... |
| 2312943 | Biliyor Musun - Sonsuz Yarış | 5.0 | 12.0 | 100+ | 100.0 | USD | 5.2M | 5.0 and up | Y Yazılım | NaN | yyazilimdevelop@gmail.com | Aug 9, 2019 | https://biliyor-musun-sons.flycricket.io/priva... |
2312944 rows × 13 columns
In [18]:
playstore.dropna(axis=0, inplace = True)
In [19]:
na_counts = playstore.isna().sum()
na_counts = na_counts.to_frame().reset_index()
na_counts.columns = ["col", "count"]
na_counts
Out[19]:
| col | count | |
|---|---|---|
| 0 | App Name | 0 |
| 1 | App Id | 0 |
| 2 | Category | 0 |
| 3 | Rating | 0 |
| 4 | Rating Count | 0 |
| 5 | Installs | 0 |
| 6 | Minimum Installs | 0 |
| 7 | Maximum Installs | 0 |
| 8 | Free | 0 |
| 9 | Price | 0 |
| 10 | Currency | 0 |
| 11 | Size | 0 |
| 12 | Minimum Android | 0 |
| 13 | Developer Id | 0 |
| 14 | Developer Website | 0 |
| 15 | Developer Email | 0 |
| 16 | Released | 0 |
| 17 | Last Updated | 0 |
| 18 | Content Rating | 0 |
| 19 | Privacy Policy | 0 |
| 20 | Ad Supported | 0 |
| 21 | In App Purchases | 0 |
| 22 | Editors Choice | 0 |
| 23 | Scraped Time | 0 |
In [20]:
playstore.describe(include = "object")
Out[20]:
| App Name | App Id | Category | Installs | Currency | Size | Minimum Android | Developer Id | Developer Website | Developer Email | Released | Last Updated | Content Rating | Privacy Policy | Scraped Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 | 1287191 |
| unique | 1245508 | 1287191 | 48 | 22 | 8 | 1563 | 106 | 452401 | 659753 | 561767 | 4154 | 3598 | 6 | 701772 | 67350 |
| top | Flashlight | com.ishakwe.gakondo | Education | 100+ | USD | 11M | 4.1 and up | Subsplash Inc | http://www.subsplash.com/ | appsupport@subsplash.com | Jun 24, 2020 | Jun 10, 2021 | Everyone | http://www.subsplash.com/legal/privacy | 2021-06-16 03:58:14 |
| freq | 127 | 1 | 127219 | 243612 | 1286647 | 37424 | 337652 | 5422 | 7518 | 7567 | 1156 | 6986 | 1122381 | 7468 | 40 |
In [21]:
playstore.shape
Out[21]:
(1287191, 24)
In [23]:
playstore.columns = playstore.columns.str.replace(" ", "_")
In [24]:
playstore.head()
Out[24]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Website | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Gakondo | com.ishakwe.gakondo | Adventure | 0.0 | 0.0 | 10+ | 10.0 | 15 | True | 0.0 | ... | https://beniyizibyose.tk/#/ | jean21101999@gmail.com | Feb 26, 2020 | Feb 26, 2020 | Everyone | https://beniyizibyose.tk/projects/ | False | False | False | 2021-06-15 20:19:35 |
| 1 | Ampere Battery Info | com.webserveis.batteryinfo | Tools | 4.4 | 64.0 | 5,000+ | 5000.0 | 7662 | True | 0.0 | ... | https://webserveis.netlify.app/ | webserveis@gmail.com | May 21, 2020 | May 06, 2021 | Everyone | https://dev4phones.wordpress.com/licencia-de-uso/ | True | False | False | 2021-06-15 20:19:35 |
| 4 | GROW.me | com.horodyski.grower | Tools | 0.0 | 0.0 | 100+ | 100.0 | 478 | True | 0.0 | ... | http://www.horodyski.com.pl | rmilekhorodyski@gmail.com | Feb 21, 2020 | Nov 12, 2018 | Everyone | http://www.horodyski.com.pl | False | False | False | 2021-06-15 20:19:35 |
| 5 | IMOCCI | com.imocci | Social | 0.0 | 0.0 | 50+ | 50.0 | 89 | True | 0.0 | ... | http://www.imocci.com | info@imocci.com | Dec 24, 2018 | Dec 20, 2019 | Teen | https://www.imocci.com/wp-content/uploads/2018... | False | True | False | 2021-06-15 20:19:35 |
| 9 | Neon 3d Iron Tech Keyboard Theme | com.ikeyboard.theme.neon_3d.iron.tech | Personalization | 4.7 | 820.0 | 50,000+ | 50000.0 | 62433 | True | 0.0 | ... | https://trendyteme888-31139.web.app | trendyteme.888@gmail.com | Sep 22, 2019 | Oct 07, 2020 | Everyone | http://bit.ly/EmojiThemePro | True | False | False | 2021-06-15 20:19:35 |
5 rows × 24 columns
In [25]:
playstore.Currency.unique()
Out[25]:
array(['USD', 'XXX', 'VND', 'GBP', 'INR', 'TRY', 'EUR', 'ZAR'],
dtype=object)
In [26]:
playstore.Installs.unique()
Out[26]:
array(['10+', '5,000+', '100+', '50+', '50,000+', '10,000+', '1,000+',
'500+', '500,000+', '100,000+', '10,000,000+', '1+', '1,000,000+',
'5+', '5,000,000+', '100,000,000+', '0+', '50,000,000+',
'1,000,000,000+', '500,000,000+', '5,000,000,000+',
'10,000,000,000+'], dtype=object)
In [27]:
playstore.Content_Rating.unique()
Out[27]:
array(['Everyone', 'Teen', 'Everyone 10+', 'Mature 17+',
'Adults only 18+', 'Unrated'], dtype=object)
In [28]:
playstore.Category.unique()
Out[28]:
array(['Adventure', 'Tools', 'Social', 'Personalization',
'Maps & Navigation', 'Travel & Local', 'Food & Drink', 'Puzzle',
'Entertainment', 'Photography', 'Health & Fitness', 'Shopping',
'Books & Reference', 'Beauty', 'Business', 'Educational',
'Lifestyle', 'Music & Audio', 'News & Magazines',
'Auto & Vehicles', 'Productivity', 'Education', 'Art & Design',
'House & Home', 'Racing', 'Sports', 'Events', 'Finance', 'Weather',
'Board', 'Medical', 'Communication', 'Word', 'Action', 'Trivia',
'Simulation', 'Video Players & Editors', 'Music', 'Arcade',
'Libraries & Demo', 'Casual', 'Dating', 'Strategy', 'Card',
'Role Playing', 'Casino', 'Parenting', 'Comics'], dtype=object)
In [29]:
playstore.App_Name.unique()
Out[29]:
array(['Gakondo', 'Ampere Battery Info', 'GROW.me', ...,
'Caustic Editor for VolcaSample', 'Lero TOEFL Recorder + Timer',
'ORU Online'], dtype=object)
In [30]:
playstore.Category.value_counts()
Out[30]:
Education 127219 Business 100311 Music & Audio 87008 Lifestyle 75017 Tools 67215 Entertainment 63581 Books & Reference 56515 Health & Fitness 51770 Shopping 48981 Productivity 46960 Travel & Local 46613 Food & Drink 45773 Finance 44111 Personalization 37819 Communication 30703 News & Magazines 29320 Sports 29180 Social 27164 Puzzle 25069 Casual 21958 Medical 20260 Arcade 19925 Photography 16827 Maps & Navigation 15821 Educational 13048 Simulation 12569 Action 12385 Auto & Vehicles 10744 Adventure 10295 House & Home 8707 Events 8497 Art & Design 8007 Video Players & Editors 6883 Beauty 6179 Trivia 5885 Role Playing 5711 Racing 5383 Board 5175 Word 4989 Card 4858 Strategy 4117 Weather 4103 Dating 3429 Casino 2810 Parenting 2381 Libraries & Demo 2371 Music 2200 Comics 1345 Name: Category, dtype: int64
In [31]:
#Question 1 (Top 5 Categories of Apps)
df = playstore.Category.rename_axis("Category").value_counts().reset_index(name = "counts").head()
df
Out[31]:
| index | counts | |
|---|---|---|
| 0 | Education | 127219 |
| 1 | Business | 100311 |
| 2 | Music & Audio | 87008 |
| 3 | Lifestyle | 75017 |
| 4 | Tools | 67215 |
In [32]:
fig= px.bar(df,y="counts",x="index")
fig.show()
In [33]:
#Question 2(Most Expensive App)
playstore[playstore["Price"] == 400]
Out[33]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Website | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 544468 | MESH Connect | com.tecit.android.bluepiano.meshconnectfull | Productivity | 0.0 | 0.0 | 10+ | 10.0 | 25 | False | 400.0 | ... | http://www.go-evo.com | support@go-evo.com | Sep 7, 2017 | Sep 07, 2017 | Everyone | http://www.go-evo.com/privacy | False | False | False | 2021-06-16 05:15:22 |
1 rows × 24 columns
In [34]:
#Question 3(High Rated App)
playstore[playstore["Rating"] == 5]
Out[34]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Website | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116 | ignite | com.torch.ignite | Events | 5.0 | 21.0 | 100+ | 100.0 | 224 | True | 0.0 | ... | http://www.peilee.com | asdfg3865@gmail.com | Jun 22, 2018 | Jul 04, 2018 | Everyone | https://alvinyang10919058.wixsite.com/privacyp... | False | False | False | 2021-06-15 20:19:42 |
| 169 | San Jose Gurdwara | sanjose.gurdwara.com.sanjosegurdwara | Social | 5.0 | 10.0 | 500+ | 500.0 | 779 | True | 0.0 | ... | http://sanjosegurdwara.org | swapna.jadhav14@gmail.com | Apr 8, 2018 | Aug 20, 2019 | Everyone | http://sanjosegurdwara.org/privacy_policy.html | False | False | False | 2021-06-15 20:19:45 |
| 290 | Tekman Batur | appinventor.ai_ttaslicay.TekmanBatur | Travel & Local | 5.0 | 5.0 | 50+ | 50.0 | 51 | True | 0.0 | ... | https://tekmanbatur.blogspot.com/ | kazakmedya@gmail.com | May 14, 2020 | May 19, 2020 | Everyone | https://tekmanbatur.blogspot.com/p/gizlilik-po... | False | False | False | 2021-06-15 20:19:53 |
| 329 | Fazzaco | com.stl.fazzaco | Business | 5.0 | 156.0 | 10,000+ | 10000.0 | 11354 | True | 0.0 | ... | https://www.fazzaco.com/ | service@fazzaco.com | Jun 9, 2020 | May 17, 2021 | Everyone | https://www.fazzaco.com/getPrivacyAgreement | True | False | False | 2021-06-15 20:19:55 |
| 410 | POOL CAR APP | com.mpowercab.mpowercab | Education | 5.0 | 5.0 | 50+ | 50.0 | 58 | True | 0.0 | ... | http://beingwireless.in/ | beingwireless@gmail.com | Dec 9, 2019 | Dec 09, 2019 | Everyone | http://beingwireless.in/privacy.html | False | False | False | 2021-06-15 20:20:00 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2312767 | Quintero Asociados | co.grupoata.quinteroasociados | Productivity | 5.0 | 5.0 | 50+ | 50.0 | 82 | True | 0.0 | ... | http://www.grupoata.co | info@grupoata.co | Sep 26, 2018 | Dec 16, 2020 | Everyone | http://grupoata.co/politica-informacion.html | False | False | False | 2021-06-16 12:59:09 |
| 2312783 | France Bycott | com.developerworkerz.francebycot | Social | 5.0 | 22.0 | 10+ | 10.0 | 40 | True | 0.0 | ... | https://loopahoption.wixsite.com/france-boycott | usamaahmedsunny@gmail.com | Nov 10, 2020 | Nov 17, 2020 | Everyone | https://loopahoption.wixsite.com/france-boycott | True | False | False | 2021-06-16 12:59:10 |
| 2312815 | Buy Tiffin | com.buytiffin | Food & Drink | 5.0 | 59.0 | 500+ | 500.0 | 511 | True | 0.0 | ... | https://buytiffin.in | info@buytiffin.in | Aug 3, 2019 | Feb 17, 2020 | Everyone | https://buytiffin.in/privacy-policy-for-app/ | False | False | False | 2021-06-16 12:59:12 |
| 2312880 | Crown Office bazaar | com.crown_office_bazaar.crown0fficebazaar | Business | 5.0 | 5.0 | 50+ | 50.0 | 51 | True | 0.0 | ... | https://www.crownofficebazaar.com/ | support@crownofficebazaar.com | Sep 6, 2020 | Sep 29, 2020 | Everyone | http://www.crownofficebazaar.com/privacy-policy | False | False | False | 2021-06-16 12:59:15 |
| 2312909 | Century College | com.readyeducation.centurycollege | Education | 5.0 | 10.0 | 100+ | 100.0 | 230 | True | 0.0 | ... | https://www.readyeducation.com | support@readyeducation.com | Aug 26, 2020 | May 24, 2021 | Everyone | https://www.readyeducation.com/privacy | False | False | False | 2021-06-16 12:59:17 |
52774 rows × 24 columns
In [35]:
playstore[playstore["Rating"] == 5.0]
Out[35]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Website | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116 | ignite | com.torch.ignite | Events | 5.0 | 21.0 | 100+ | 100.0 | 224 | True | 0.0 | ... | http://www.peilee.com | asdfg3865@gmail.com | Jun 22, 2018 | Jul 04, 2018 | Everyone | https://alvinyang10919058.wixsite.com/privacyp... | False | False | False | 2021-06-15 20:19:42 |
| 169 | San Jose Gurdwara | sanjose.gurdwara.com.sanjosegurdwara | Social | 5.0 | 10.0 | 500+ | 500.0 | 779 | True | 0.0 | ... | http://sanjosegurdwara.org | swapna.jadhav14@gmail.com | Apr 8, 2018 | Aug 20, 2019 | Everyone | http://sanjosegurdwara.org/privacy_policy.html | False | False | False | 2021-06-15 20:19:45 |
| 290 | Tekman Batur | appinventor.ai_ttaslicay.TekmanBatur | Travel & Local | 5.0 | 5.0 | 50+ | 50.0 | 51 | True | 0.0 | ... | https://tekmanbatur.blogspot.com/ | kazakmedya@gmail.com | May 14, 2020 | May 19, 2020 | Everyone | https://tekmanbatur.blogspot.com/p/gizlilik-po... | False | False | False | 2021-06-15 20:19:53 |
| 329 | Fazzaco | com.stl.fazzaco | Business | 5.0 | 156.0 | 10,000+ | 10000.0 | 11354 | True | 0.0 | ... | https://www.fazzaco.com/ | service@fazzaco.com | Jun 9, 2020 | May 17, 2021 | Everyone | https://www.fazzaco.com/getPrivacyAgreement | True | False | False | 2021-06-15 20:19:55 |
| 410 | POOL CAR APP | com.mpowercab.mpowercab | Education | 5.0 | 5.0 | 50+ | 50.0 | 58 | True | 0.0 | ... | http://beingwireless.in/ | beingwireless@gmail.com | Dec 9, 2019 | Dec 09, 2019 | Everyone | http://beingwireless.in/privacy.html | False | False | False | 2021-06-15 20:20:00 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2312767 | Quintero Asociados | co.grupoata.quinteroasociados | Productivity | 5.0 | 5.0 | 50+ | 50.0 | 82 | True | 0.0 | ... | http://www.grupoata.co | info@grupoata.co | Sep 26, 2018 | Dec 16, 2020 | Everyone | http://grupoata.co/politica-informacion.html | False | False | False | 2021-06-16 12:59:09 |
| 2312783 | France Bycott | com.developerworkerz.francebycot | Social | 5.0 | 22.0 | 10+ | 10.0 | 40 | True | 0.0 | ... | https://loopahoption.wixsite.com/france-boycott | usamaahmedsunny@gmail.com | Nov 10, 2020 | Nov 17, 2020 | Everyone | https://loopahoption.wixsite.com/france-boycott | True | False | False | 2021-06-16 12:59:10 |
| 2312815 | Buy Tiffin | com.buytiffin | Food & Drink | 5.0 | 59.0 | 500+ | 500.0 | 511 | True | 0.0 | ... | https://buytiffin.in | info@buytiffin.in | Aug 3, 2019 | Feb 17, 2020 | Everyone | https://buytiffin.in/privacy-policy-for-app/ | False | False | False | 2021-06-16 12:59:12 |
| 2312880 | Crown Office bazaar | com.crown_office_bazaar.crown0fficebazaar | Business | 5.0 | 5.0 | 50+ | 50.0 | 51 | True | 0.0 | ... | https://www.crownofficebazaar.com/ | support@crownofficebazaar.com | Sep 6, 2020 | Sep 29, 2020 | Everyone | http://www.crownofficebazaar.com/privacy-policy | False | False | False | 2021-06-16 12:59:15 |
| 2312909 | Century College | com.readyeducation.centurycollege | Education | 5.0 | 10.0 | 100+ | 100.0 | 230 | True | 0.0 | ... | https://www.readyeducation.com | support@readyeducation.com | Aug 26, 2020 | May 24, 2021 | Everyone | https://www.readyeducation.com/privacy | False | False | False | 2021-06-16 12:59:17 |
52774 rows × 24 columns
In [36]:
#Question 5 (Oldest App on the Playstore)
playstore['Released_New'] = pd.to_datetime(playstore['Released']).dt.date
playstore['Released_New']
Out[36]:
0 2020-02-26
1 2020-05-21
4 2020-02-21
5 2018-12-24
9 2019-09-22
...
2312933 2014-12-11
2312934 2020-06-15
2312938 2018-05-22
2312940 2018-01-17
2312942 2016-08-01
Name: Released_New, Length: 1287191, dtype: object
In [37]:
playstore['Released_New'].min()
Out[37]:
datetime.date(2010, 1, 28)
In [34]:
playstore[playstore['Released_New']==playstore['Released_New'].min()]
Out[34]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1005858 | Packing List | com.dotnetideas.packinglist | Travel & Local | 4.0 | 965.0 | 100,000+ | 100000.0 | 250363 | True | 0.00 | ... | support@dotnetideas.com | Jan 28, 2010 | Aug 07, 2019 | Everyone | https://www.dotnetideas.com/home/PrivacyPolicy | True | False | False | 2021-06-16 12:24:26 | 2010-01-28 |
| 1286316 | Pubtran | cz.fhejl.pubtran | Maps & Navigation | 4.6 | 24248.0 | 1,000,000+ | 1000000.0 | 1047316 | True | 0.00 | ... | jizdnirady@firma.seznam.cz | Jan 28, 2010 | Jan 14, 2021 | Everyone | https://napoveda.seznam.cz/en/personal-data-pr... | False | False | False | 2021-06-15 21:58:38 | 2010-01-28 |
| 1303450 | TweetCaster for Twitter | com.handmark.tweetcaster | Social | 4.0 | 517738.0 | 10,000,000+ | 10000000.0 | 11884201 | True | 0.00 | ... | support@onelouder.com | Jan 28, 2010 | Feb 28, 2021 | Teen | http://tweetcaster.com/privacy | True | True | False | 2021-06-15 22:13:37 | 2010-01-28 |
| 2052352 | TweetCaster Pro for Twitter | com.handmark.tweetcaster.premium | Social | 3.9 | 24284.0 | 100,000+ | 100000.0 | 102129 | False | 4.99 | ... | support@onelouder.com | Jan 28, 2010 | Mar 02, 2021 | Teen | http://tweetcaster.com/privacy | False | False | False | 2021-06-16 09:11:58 | 2010-01-28 |
| 2285011 | VIP Access | com.verisign.mvip.main | Tools | 4.0 | 15679.0 | 5,000,000+ | 5000000.0 | 6775296 | True | 0.00 | ... | vip.mobilesupport@broadcom.com | Jan 28, 2010 | Nov 18, 2019 | Everyone | https://www.symantec.com/privacy | False | False | False | 2021-06-16 12:34:40 | 2010-01-28 |
5 rows × 25 columns
In [22]:
#Question 4 (Max installed App)
playstore.Maximum_Installs.max()
--------------------------------------------------------------------------- AttributeError Traceback (most recent call last) ~\AppData\Local\Temp/ipykernel_10624/2089670649.py in <module> 1 #Question 4 (Max installed App) ----> 2 playstore.Maximum_Installs.max() ~\anaconda3\lib\site-packages\pandas\core\generic.py in __getattr__(self, name) 5485 ): 5486 return self[name] -> 5487 return object.__getattribute__(self, name) 5488 5489 def __setattr__(self, name: str, value) -> None: AttributeError: 'DataFrame' object has no attribute 'Maximum_Installs'
In [36]:
#12057627016
playstore[playstore["Maximum_Installs"] == 12057627016]
Out[36]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2155096 | Google Play services | com.google.android.gms | Tools | 4.2 | 35128398.0 | 10,000,000,000+ | 1.000000e+10 | 12057627016 | True | 0.0 | ... | apps-help@google.com | May 24, 2012 | Jun 10, 2021 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-16 10:41:26 | 2012-05-24 |
1 rows × 25 columns
In [37]:
#1.205763e+10
playstore.describe()
Out[37]:
| Rating | Rating_Count | Minimum_Installs | Maximum_Installs | Price | |
|---|---|---|---|---|---|
| count | 1.287191e+06 | 1.287191e+06 | 1.287191e+06 | 1.287191e+06 | 1.287191e+06 |
| mean | 2.315500e+00 | 4.470702e+03 | 2.691305e+05 | 4.676076e+05 | 1.099716e-01 |
| std | 2.090373e+00 | 2.594790e+05 | 1.834388e+07 | 2.780474e+07 | 2.438043e+00 |
| min | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 | 0.000000e+00 |
| 25% | 0.000000e+00 | 0.000000e+00 | 1.000000e+02 | 1.150000e+02 | 0.000000e+00 |
| 50% | 3.300000e+00 | 7.000000e+00 | 5.000000e+02 | 9.490000e+02 | 0.000000e+00 |
| 75% | 4.300000e+00 | 6.100000e+01 | 1.000000e+04 | 1.074300e+04 | 0.000000e+00 |
| max | 5.000000e+00 | 1.385576e+08 | 1.000000e+10 | 1.205763e+10 | 4.000000e+02 |
In [38]:
#Question 7(Rating Analysis, Distribution of App Ratings)
fig= px.histogram(playstore,x="Rating")
fig.show()
In [39]:
#Qusetion 6(Ratio of apps that supported ads & that don't)
print(playstore.Ad_Supported.value_counts())
Ads = playstore.Ad_Supported.value_counts(normalize=True)*100
Ads
False 712073 True 575118 Name: Ad_Supported, dtype: int64
Out[39]:
False 55.319918 True 44.680082 Name: Ad_Supported, dtype: float64
In [40]:
575118/712073
Out[40]:
0.8076671914255982
In [41]:
fig= px.pie(Ads,values="Ad_Supported",names=['False', 'True'],color_discrete_sequence=px.colors.sequential.RdBu)
fig.show()
In [42]:
#Question 8 (List of All Shooting games within Playstore data)
category=playstore[playstore.Category=='Action']
category
Out[42]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221 | John Brick | com.AppsBergman.JohnBrick | Action | 3.9 | 11.0 | 500+ | 500.0 | 522 | True | 0.0 | ... | contato@appsbergman.com | Mar 19, 2021 | Mar 22, 2021 | Teen | http://appsbergman.com/privacy_policy.html | True | False | False | 2021-06-15 20:19:49 | 2021-03-19 |
| 504 | Balloon Popper | com.aplications.adimov.balonkids | Action | 4.8 | 19.0 | 100+ | 100.0 | 153 | True | 0.0 | ... | adimov742@gmail.com | Dec 28, 2018 | Mar 31, 2021 | Everyone | https://sites.google.com/view/mypolicypri/p%C3... | True | False | False | 2021-06-15 20:20:05 | 2018-12-28 |
| 811 | Imran Khan vs Nawaz Sharif | com.mypolitician.appdata.juni1289 | Action | 4.0 | 21.0 | 5,000+ | 5000.0 | 8582 | True | 0.0 | ... | extremecode1289@gmail.com | Sep 7, 2016 | Jun 05, 2017 | Everyone | https://extremecodeblog.wordpress.com/privacy-... | True | False | False | 2021-06-15 20:20:22 | 2016-09-07 |
| 920 | Counter Strike Shooting Game: Special Ops Shoo... | com.ea.usarmy.counter.strike.shooting | Action | 4.7 | 979.0 | 100,000+ | 100000.0 | 117176 | True | 0.0 | ... | contact.epiphanyatelier1@gmail.com | May 7, 2020 | May 11, 2021 | Teen | https://docs.google.com/document/d/1XneMJYLpTF... | True | False | False | 2021-06-15 20:20:29 | 2020-05-07 |
| 1593 | Running Stick | com.zplay.runningstick | Action | 4.0 | 156.0 | 10,000+ | 10000.0 | 34691 | True | 0.0 | ... | contact@zplay.com | Jun 19, 2017 | Aug 04, 2017 | Everyone | http://games.zplay.com/en/ZplayPrivacyPolicy.html | True | False | False | 2021-06-15 20:21:08 | 2017-06-19 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2311750 | Paintball Shooter 3D | com.clashgamez.paintball.shooter3d.fighting.arena | Action | 2.8 | 1220.0 | 100,000+ | 100000.0 | 292578 | True | 0.0 | ... | clashgamezstudio@gmail.com | Dec 5, 2019 | Feb 12, 2020 | Everyone 10+ | https://docs.google.com/document/d/1Ex8nIfNDgW... | True | False | False | 2021-06-16 12:58:16 | 2019-12-05 |
| 2312067 | Battle Royale Fire Prime Free: Online & Offline | com.firstanvilgames.battle.shooter.fps.Battleg... | Action | 3.9 | 2944.0 | 100,000+ | 100000.0 | 450941 | True | 0.0 | ... | 20starteam20@gmail.com | Apr 1, 2021 | May 21, 2021 | Teen | https://docs.google.com/document/d/1ShDk_QIv54... | True | True | False | 2021-06-16 12:58:32 | 2021-04-01 |
| 2312357 | Last Saber | com.gempack.troops | Action | 3.5 | 22.0 | 1,000+ | 1000.0 | 4716 | True | 0.0 | ... | contact@gempack.co.kr | Sep 14, 2018 | Feb 04, 2021 | Everyone | http://www.gempack.kr/privacy_policy/last_sabe... | True | False | False | 2021-06-16 12:58:47 | 2018-09-14 |
| 2312557 | Funny Mercenary - MOBA DOTA | com.MagicCard.FunnyMercenary | Action | 0.0 | 0.0 | 5,000+ | 5000.0 | 7343 | True | 0.0 | ... | magiccard2005@gmail.com | Dec 7, 2016 | Jul 31, 2020 | Teen | https://funny-mercenary.flycricket.io/privacy.... | True | True | False | 2021-06-16 12:58:58 | 2016-12-07 |
| 2312932 | Hopeless 2: Cave Escape | com.upopa.hopeless2 | Action | 4.3 | 103466.0 | 5,000,000+ | 5000000.0 | 7274660 | True | 0.0 | ... | support@upopa.com | Oct 29, 2015 | Mar 06, 2017 | Teen | http://www.upopa.com/games/hopeless2/privacypo... | True | True | False | 2021-06-16 12:59:18 | 2015-10-29 |
12385 rows × 25 columns
In [43]:
category[category.App_Name.str.contains("kill|shoot|war|fight|crime|action")]
Out[43]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2736 | Counter FPS shooting strike: New shooting games | com.sfgs.counter.shooting.strike.shooting.games | Action | 4.1 | 79.0 | 10,000+ | 10000.0 | 20199 | True | 0.00 | ... | sunshinefightinggames@yahoo.com | Apr 25, 2020 | Apr 25, 2020 | Teen | https://sites.google.com/view/sunshine-freegam... | True | False | False | 2021-06-15 20:22:13 | 2020-04-25 |
| 5086 | Blocky Cars - pixel shooter & tank wars | com.blockycars.online | Action | 4.4 | 428863.0 | 10,000,000+ | 10000000.0 | 25055030 | True | 0.00 | ... | blocky.cars@fullhpltd.com | Jul 10, 2015 | Apr 22, 2021 | Everyone 10+ | http://fullhpltd.com/this-privacy-policy/ | True | True | False | 2021-06-15 20:24:29 | 2015-07-10 |
| 19145 | Z.O.N.A Project X - Post-apocalyptic shooter. | com.agaming.zonaprojectx | Action | 3.0 | 8167.0 | 100,000+ | 100000.0 | 234719 | False | 0.99 | ... | agamingandroid@gmail.com | Aug 22, 2015 | Nov 15, 2019 | Mature 17+ | http://eagaming.org/pages/privacy-policy-googl... | False | False | False | 2021-06-15 20:38:17 | 2015-08-22 |
| 21490 | Zombie Smasher Squad: Deadly Roadkill Car Surv... | com.futurealiti.zombie.smasher.squad.deadly.ro... | Action | 4.4 | 7.0 | 1,000+ | 1000.0 | 1980 | True | 0.00 | ... | devaccounts@futurealiti.com | Apr 10, 2020 | Apr 25, 2020 | Teen | https://futurealiti.com/privacy-policy/ | True | True | False | 2021-06-15 20:40:33 | 2020-04-10 |
| 23512 | HumV Dogs Legend : Offline cartoon racing action | com.guris.humvdogslegend | Action | 4.4 | 45.0 | 10,000+ | 10000.0 | 12953 | True | 0.00 | ... | searoopy@gmail.com | Jun 29, 2020 | Feb 08, 2021 | Everyone | https://passman.tistory.com/category/DFFFFF | True | True | False | 2021-06-15 20:42:32 | 2020-06-29 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2285069 | Pot shooter | com.cybearcode.potshooter | Action | 0.0 | 0.0 | 1,000+ | 1000.0 | 1678 | True | 0.00 | ... | contact@cybearcode.com | Apr 14, 2021 | May 31, 2021 | Everyone | https://cybearcode.com/privacy-policy | True | True | False | 2021-06-16 12:34:43 | 2021-04-14 |
| 2288356 | army fight | com.virtualinfocom.army.fight | Action | 4.0 | 24.0 | 1,000+ | 1000.0 | 2745 | True | 0.00 | ... | arijit79in@gmail.com | Feb 15, 2017 | Aug 02, 2018 | Teen | http://ani2pix.com/policy.html | True | False | False | 2021-06-16 12:37:39 | 2017-02-15 |
| 2291282 | One Gun 2 Stickman rpg shooter gang | com.erow.stickgun2 | Action | 4.4 | 367.0 | 100,000+ | 100000.0 | 435844 | True | 0.00 | ... | erowhelp@gmail.com | Jul 9, 2019 | Jun 15, 2021 | Everyone 10+ | https://erowdev-ffb62.firebaseapp.com/privacy_... | True | True | False | 2021-06-16 12:40:11 | 2019-07-09 |
| 2295188 | Star Forces: Space shooter | com.azurinteractive.StarForces | Action | 3.3 | 11110.0 | 1,000,000+ | 1000000.0 | 1022390 | True | 0.00 | ... | zar@azurgames.com | Feb 21, 2019 | Apr 02, 2019 | Teen | https://privacy.azurgames.com | True | True | False | 2021-06-16 12:43:37 | 2019-02-21 |
| 2311434 | Superhero fighter king: Spider Fighting games | com.epic_games.superhero.fighter.king | Action | 4.9 | 221.0 | 10,000+ | 10000.0 | 24287 | True | 0.00 | ... | epicgamesworld40@gmail.com | Sep 5, 2019 | Jul 06, 2020 | Teen | https://epicgamesworld.weebly.com/ | True | False | False | 2021-06-16 12:58:00 | 2019-09-05 |
355 rows × 25 columns
In [44]:
#Question 9 (Rating Analysis in each category of apps(Top 3))
playstore.Category.value_counts()
Out[44]:
Education 127219 Business 100311 Music & Audio 87008 Lifestyle 75017 Tools 67215 Entertainment 63581 Books & Reference 56515 Health & Fitness 51770 Shopping 48981 Productivity 46960 Travel & Local 46613 Food & Drink 45773 Finance 44111 Personalization 37819 Communication 30703 News & Magazines 29320 Sports 29180 Social 27164 Puzzle 25069 Casual 21958 Medical 20260 Arcade 19925 Photography 16827 Maps & Navigation 15821 Educational 13048 Simulation 12569 Action 12385 Auto & Vehicles 10744 Adventure 10295 House & Home 8707 Events 8497 Art & Design 8007 Video Players & Editors 6883 Beauty 6179 Trivia 5885 Role Playing 5711 Racing 5383 Board 5175 Word 4989 Card 4858 Strategy 4117 Weather 4103 Dating 3429 Casino 2810 Parenting 2381 Libraries & Demo 2371 Music 2200 Comics 1345 Name: Category, dtype: int64
In [45]:
# Education, Business, Music & Audio
df1 = playstore.Category.value_counts().reset_index(name = "counts").head(3)
df1
Out[45]:
| index | counts | |
|---|---|---|
| 0 | Education | 127219 |
| 1 | Business | 100311 |
| 2 | Music & Audio | 87008 |
In [46]:
fig= px.histogram(playstore[playstore.Category=='Education'],x="Rating")
fig.show()
In [47]:
fig= px.histogram(playstore[playstore.Category=='Business'],x="Rating")
fig.show()
In [48]:
fig= px.histogram(playstore[playstore.Category=='Music & Audio'],x="Rating")
fig.show()
In [49]:
#Question 13(Last Updated App in the Playstore)
playstore['Last_Updated_New'] = pd.to_datetime(playstore['Last_Updated']).dt.date
playstore['Last_Updated_New']
Out[49]:
0 2020-02-26
1 2021-05-06
4 2018-11-12
5 2019-12-20
9 2020-10-07
...
2312933 2014-12-11
2312934 2020-08-31
2312938 2018-12-14
2312940 2018-02-02
2312942 2021-05-05
Name: Last_Updated_New, Length: 1287191, dtype: object
In [50]:
playstore['Last_Updated_New'].max()
Out[50]:
datetime.date(2021, 6, 16)
In [51]:
playstore[playstore['Last_Updated_New']==playstore['Last_Updated_New'].max()]
Out[51]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | Last_Updated_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 309976 | Simplify Fitness | com.trainerize.simplifyfitness | Health & Fitness | 0.0 | 0.0 | 1+ | 1.0 | 4 | True | 0.0 | ... | Nov 16, 2017 | Jun 16, 2021 | Everyone | http://www.trainerize.com/privacy.aspx | False | False | False | 2021-06-16 01:38:59 | 2017-11-16 | 2021-06-16 |
| 316480 | SUSS Reader | sg.edu.suss.etp.sreader2 | Education | 1.7 | 7.0 | 1,000+ | 1000.0 | 1604 | True | 0.0 | ... | Aug 29, 2019 | Jun 16, 2021 | Everyone | http://www.suss.edu.sg/Pages/Privacy-Policy.aspx | False | False | False | 2021-06-16 01:45:34 | 2019-08-29 | 2021-06-16 |
| 339988 | Field Pro by ION Solar | com.ionsolar.fieldpro | Tools | 0.0 | 0.0 | 100+ | 100.0 | 256 | True | 0.0 | ... | Jun 26, 2019 | Jun 16, 2021 | Everyone | https://ionsolar.com/privacy/ | False | False | False | 2021-06-16 02:08:13 | 2019-06-26 | 2021-06-16 |
| 340610 | BreakOut - Video Conference,Meeting,Seminar | com.haedenbridge.moyeee.meeting | Business | 3.3 | 52.0 | 10,000+ | 10000.0 | 30709 | True | 0.0 | ... | Nov 1, 2018 | Jun 16, 2021 | Everyone | http://www.breakout.cloud/policy/kr/privacy.html | False | False | False | 2021-06-16 02:08:49 | 2018-11-01 | 2021-06-16 |
| 343467 | Grow Soldier - Merge Soldier | com.pixelstar.GrowSoldier | Adventure | 3.8 | 1438.0 | 100,000+ | 100000.0 | 326701 | True | 0.0 | ... | Jan 30, 2019 | Jun 16, 2021 | Teen | https://pixelstargames.blogspot.com/ | True | True | False | 2021-06-16 02:11:35 | 2019-01-30 | 2021-06-16 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2310083 | Al Rifai Arabia | com.alrifaiarabia | Business | 3.4 | 65.0 | 10,000+ | 10000.0 | 36456 | True | 0.0 | ... | Sep 27, 2020 | Jun 16, 2021 | Everyone | https://alrifaiarabia.com/privacy-policy | False | False | False | 2021-06-16 12:56:49 | 2020-09-27 | 2021-06-16 |
| 2310879 | I'm home アイムホーム | com.audiencemedia.app465.issue3491 | Art & Design | 0.0 | 0.0 | 5+ | 5.0 | 6 | True | 0.0 | ... | May 20, 2019 | Jun 16, 2021 | Everyone | https://www.shotenkenchiku.com/guide/privacy.php | True | True | False | 2021-06-16 12:57:31 | 2019-05-20 | 2021-06-16 |
| 2311575 | 4 Images 1 Mot | de.lotum.whatsinthefoto.fr | Word | 4.4 | 384932.0 | 10,000,000+ | 10000000.0 | 19549176 | True | 0.0 | ... | Dec 22, 2016 | Jun 16, 2021 | Everyone 10+ | https://lotum.com/privacy-policy.html | True | True | False | 2021-06-16 12:58:07 | 2016-12-22 | 2021-06-16 |
| 2311589 | Fake call - Girlfriend Prank | com.sexygirl.videocall.prank | Entertainment | 2.8 | 6.0 | 100,000+ | 100000.0 | 109986 | True | 0.0 | ... | Jan 4, 2021 | Jun 16, 2021 | Mature 17+ | https://sites.google.com/view/thezeeapp | True | False | False | 2021-06-16 12:58:08 | 2021-01-04 | 2021-06-16 |
| 2312454 | AppTCC | rouenwebmaster.mobile.apptoc | Medical | 5.0 | 7.0 | 1,000+ | 1000.0 | 1478 | True | 0.0 | ... | Nov 8, 2019 | Jun 16, 2021 | Everyone | https://apptoc.fr/politique-de-confidentialite/ | False | False | False | 2021-06-16 12:58:52 | 2019-11-08 | 2021-06-16 |
1131 rows × 26 columns
In [52]:
#Question 15(Find all Apps by Google)
playstore.columns
Out[52]:
Index(['App_Name', 'App_Id', 'Category', 'Rating', 'Rating_Count', 'Installs',
'Minimum_Installs', 'Maximum_Installs', 'Free', 'Price', 'Currency',
'Size', 'Minimum_Android', 'Developer_Id', 'Developer_Website',
'Developer_Email', 'Released', 'Last_Updated', 'Content_Rating',
'Privacy_Policy', 'Ad_Supported', 'In_App_Purchases', 'Editors_Choice',
'Scraped_Time', 'Released_New', 'Last_Updated_New'],
dtype='object')
In [53]:
playstore[['Developer_Id', 'Developer_Website',
'Developer_Email']]
Out[53]:
| Developer_Id | Developer_Website | Developer_Email | |
|---|---|---|---|
| 0 | Jean Confident Irénée NIYIZIBYOSE | https://beniyizibyose.tk/#/ | jean21101999@gmail.com |
| 1 | Webserveis | https://webserveis.netlify.app/ | webserveis@gmail.com |
| 4 | Rafal Milek-Horodyski | http://www.horodyski.com.pl | rmilekhorodyski@gmail.com |
| 5 | Imocci GmbH | http://www.imocci.com | info@imocci.com |
| 9 | Free 2021 Themes for Emoji keyboard | https://trendyteme888-31139.web.app | trendyteme.888@gmail.com |
| ... | ... | ... | ... |
| 2312933 | Single Cell Software | http://www.singlecellsoftware.com | causticapp@gmail.com |
| 2312934 | Eliminates Apps | https://af24d8239.app-ads-txt.com | eliminatesapps@gmail.com |
| 2312938 | Julio Augusto Vera | https://lerodoe.wordpress.com/ | lero.doe@gmail.com |
| 2312940 | 3Dream Studios, LLC | http://www.oru.edu/ | 3DreamDeveloper@gmail.com |
| 2312942 | Bhakti | https://a70f78905.app-ads-txt.com | ruchisono@gmail.com |
1287191 rows × 3 columns
In [54]:
playstore[['Developer_Id', 'Developer_Website',
'Developer_Email']][playstore[['Developer_Id', 'Developer_Website',
'Developer_Email']].Developer_Id.str.contains("Google|google")]
Out[54]:
| Developer_Id | Developer_Website | Developer_Email | |
|---|---|---|---|
| 10720 | Google Certified Developer - Mayank Sharma | https://android-breakdown.web.app | HowdyMayank@gmail.com |
| 13460 | ScaledAgile Google Developer | https://www.scaledagile.com/ | support@scaledagile.com |
| 23816 | Google Dev Blacboard | http://www.parentlink.net | support@parentlink.net |
| 26145 | Google LLC | http://www.android.com/ | apps-help@google.com |
| 29448 | Google LLC | http://eyes-free.googlecode.com/ | apps-help@google.com |
| ... | ... | ... | ... |
| 2261840 | Google LLC | http://support.google.com/wearos | apps-help@google.com |
| 2271911 | Google LLC | https://support.google.com/richmedia/answer/28... | apps-help@google.com |
| 2300539 | Google LLC | http://toontastic.com | apps-help@google.com |
| 2305532 | Google LLC | https://pay.google.com/about | google-payments@google.com |
| 2307317 | Google LLC | https://support.google.com/accounts/bin/answer... | accounts-support@google.com |
224 rows × 3 columns
In [55]:
playstore[playstore.Developer_Id.str.contains("Google|google")]
Out[55]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | Last_Updated_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10720 | Finance Records : Personal Finance & Money Man... | com.mayank.financerecords | Finance | 4.5 | 11.0 | 100+ | 100.0 | 286 | True | 0.0 | ... | Dec 22, 2020 | Feb 20, 2021 | Everyone | https://privacypolicy-mayadi.blogspot.com/p/fi... | False | False | False | 2021-06-15 20:30:03 | 2020-12-22 | 2021-02-20 |
| 13460 | SAFe Community Mobile | com.follow.SAFeCommunity | Education | 2.9 | 16.0 | 1,000+ | 1000.0 | 4648 | True | 0.0 | ... | May 30, 2019 | Feb 09, 2021 | Teen | https://www.scaledagile.com/privacy-policy/ | False | False | False | 2021-06-15 20:32:40 | 2019-05-30 | 2021-02-09 |
| 23816 | Corcoran USD | net.parentlink.corcoran | Education | 4.2 | 8.0 | 100+ | 100.0 | 396 | True | 0.0 | ... | Aug 6, 2014 | Oct 23, 2020 | Everyone | http://www.blackboard.com/legal/privacy-securi... | False | False | False | 2021-06-15 20:42:49 | 2014-08-06 | 2020-10-23 |
| 26145 | VR180 | com.google.vr.eva | Photography | 4.1 | 635.0 | 100,000+ | 100000.0 | 153207 | True | 0.0 | ... | May 3, 2018 | Dec 06, 2019 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-15 20:45:11 | 2018-05-03 | 2019-12-06 |
| 29448 | Google BrailleBack | com.googlecode.eyesfree.brailleback | Tools | 4.2 | 2599.0 | 100,000+ | 100000.0 | 231880 | True | 0.0 | ... | Jun 27, 2012 | Jun 10, 2020 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-15 20:48:41 | 2012-06-27 | 2020-06-10 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2261840 | Wear OS by Google Smartwatch | com.google.android.wearable.app | Communication | 3.7 | 244914.0 | 10,000,000+ | 10000000.0 | 30883699 | True | 0.0 | ... | Jul 2, 2014 | Jun 15, 2021 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-16 12:14:20 | 2014-07-02 | 2021-06-15 |
| 2271911 | Creative Preview | com.google.android.apps.audition | Tools | 4.4 | 1166.0 | 100,000+ | 100000.0 | 154285 | True | 0.0 | ... | Mar 4, 2015 | Jul 22, 2019 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-16 12:23:11 | 2015-03-04 | 2019-07-22 |
| 2300539 | Toontastic 3D | com.google.toontastic | Educational | 4.1 | 44501.0 | 1,000,000+ | 1000000.0 | 3325275 | True | 0.0 | ... | Jan 11, 2017 | Nov 02, 2017 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-16 12:48:22 | 2017-01-11 | 2017-11-02 |
| 2305532 | Google Pay (old app) | com.google.android.apps.walletnfcrel | Finance | 3.8 | 1059837.0 | 100,000,000+ | 100000000.0 | 330675089 | True | 0.0 | ... | Jun 24, 2011 | May 03, 2021 | Everyone | https://payments.google.com/legaldocument?fami... | False | False | False | 2021-06-16 12:52:47 | 2011-06-24 | 2021-05-03 |
| 2307317 | Google Authenticator | com.google.android.apps.authenticator2 | Tools | 3.9 | 316696.0 | 50,000,000+ | 50000000.0 | 82020853 | True | 0.0 | ... | Mar 21, 2012 | May 12, 2020 | Everyone | http://www.google.com/policies/privacy | False | False | False | 2021-06-16 12:54:20 | 2012-03-21 | 2020-05-12 |
224 rows × 26 columns
In [56]:
#Question 16 (No. of Apps within each Content_Rating Category)
playstore.Content_Rating.value_counts().reset_index(name="App_Cnt")
Out[56]:
| index | App_Cnt | |
|---|---|---|
| 0 | Everyone | 1122381 |
| 1 | Teen | 110037 |
| 2 | Mature 17+ | 34244 |
| 3 | Everyone 10+ | 20425 |
| 4 | Adults only 18+ | 85 |
| 5 | Unrated | 19 |
In [57]:
playstore.Content_Rating.value_counts().reset_index()
Out[57]:
| index | Content_Rating | |
|---|---|---|
| 0 | Everyone | 1122381 |
| 1 | Teen | 110037 |
| 2 | Mature 17+ | 34244 |
| 3 | Everyone 10+ | 20425 |
| 4 | Adults only 18+ | 85 |
| 5 | Unrated | 19 |
In [58]:
#Question 12(Most Installed/Downloaded Shooting Game App)
shootingGame=category[category.App_Name.str.contains("kill|shoot|war|fight|crime|action")]
shootingGame
Out[58]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2736 | Counter FPS shooting strike: New shooting games | com.sfgs.counter.shooting.strike.shooting.games | Action | 4.1 | 79.0 | 10,000+ | 10000.0 | 20199 | True | 0.00 | ... | sunshinefightinggames@yahoo.com | Apr 25, 2020 | Apr 25, 2020 | Teen | https://sites.google.com/view/sunshine-freegam... | True | False | False | 2021-06-15 20:22:13 | 2020-04-25 |
| 5086 | Blocky Cars - pixel shooter & tank wars | com.blockycars.online | Action | 4.4 | 428863.0 | 10,000,000+ | 10000000.0 | 25055030 | True | 0.00 | ... | blocky.cars@fullhpltd.com | Jul 10, 2015 | Apr 22, 2021 | Everyone 10+ | http://fullhpltd.com/this-privacy-policy/ | True | True | False | 2021-06-15 20:24:29 | 2015-07-10 |
| 19145 | Z.O.N.A Project X - Post-apocalyptic shooter. | com.agaming.zonaprojectx | Action | 3.0 | 8167.0 | 100,000+ | 100000.0 | 234719 | False | 0.99 | ... | agamingandroid@gmail.com | Aug 22, 2015 | Nov 15, 2019 | Mature 17+ | http://eagaming.org/pages/privacy-policy-googl... | False | False | False | 2021-06-15 20:38:17 | 2015-08-22 |
| 21490 | Zombie Smasher Squad: Deadly Roadkill Car Surv... | com.futurealiti.zombie.smasher.squad.deadly.ro... | Action | 4.4 | 7.0 | 1,000+ | 1000.0 | 1980 | True | 0.00 | ... | devaccounts@futurealiti.com | Apr 10, 2020 | Apr 25, 2020 | Teen | https://futurealiti.com/privacy-policy/ | True | True | False | 2021-06-15 20:40:33 | 2020-04-10 |
| 23512 | HumV Dogs Legend : Offline cartoon racing action | com.guris.humvdogslegend | Action | 4.4 | 45.0 | 10,000+ | 10000.0 | 12953 | True | 0.00 | ... | searoopy@gmail.com | Jun 29, 2020 | Feb 08, 2021 | Everyone | https://passman.tistory.com/category/DFFFFF | True | True | False | 2021-06-15 20:42:32 | 2020-06-29 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 2285069 | Pot shooter | com.cybearcode.potshooter | Action | 0.0 | 0.0 | 1,000+ | 1000.0 | 1678 | True | 0.00 | ... | contact@cybearcode.com | Apr 14, 2021 | May 31, 2021 | Everyone | https://cybearcode.com/privacy-policy | True | True | False | 2021-06-16 12:34:43 | 2021-04-14 |
| 2288356 | army fight | com.virtualinfocom.army.fight | Action | 4.0 | 24.0 | 1,000+ | 1000.0 | 2745 | True | 0.00 | ... | arijit79in@gmail.com | Feb 15, 2017 | Aug 02, 2018 | Teen | http://ani2pix.com/policy.html | True | False | False | 2021-06-16 12:37:39 | 2017-02-15 |
| 2291282 | One Gun 2 Stickman rpg shooter gang | com.erow.stickgun2 | Action | 4.4 | 367.0 | 100,000+ | 100000.0 | 435844 | True | 0.00 | ... | erowhelp@gmail.com | Jul 9, 2019 | Jun 15, 2021 | Everyone 10+ | https://erowdev-ffb62.firebaseapp.com/privacy_... | True | True | False | 2021-06-16 12:40:11 | 2019-07-09 |
| 2295188 | Star Forces: Space shooter | com.azurinteractive.StarForces | Action | 3.3 | 11110.0 | 1,000,000+ | 1000000.0 | 1022390 | True | 0.00 | ... | zar@azurgames.com | Feb 21, 2019 | Apr 02, 2019 | Teen | https://privacy.azurgames.com | True | True | False | 2021-06-16 12:43:37 | 2019-02-21 |
| 2311434 | Superhero fighter king: Spider Fighting games | com.epic_games.superhero.fighter.king | Action | 4.9 | 221.0 | 10,000+ | 10000.0 | 24287 | True | 0.00 | ... | epicgamesworld40@gmail.com | Sep 5, 2019 | Jul 06, 2020 | Teen | https://epicgamesworld.weebly.com/ | True | False | False | 2021-06-16 12:58:00 | 2019-09-05 |
355 rows × 25 columns
In [59]:
shootingGame[shootingGame.Maximum_Installs== shootingGame.Maximum_Installs.max()]
Out[59]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Developer_Email | Released | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 438723 | West Gunfighter | com.cg.cowboy | Action | 4.2 | 512701.0 | 50,000,000+ | 50000000.0 | 87632801 | True | 0.0 | ... | contact@candy-mobile.com | Apr 19, 2018 | Nov 14, 2019 | Teen | http://www2.candy-mobile.com/policy.htm | True | True | False | 2021-06-16 03:40:12 | 2018-04-19 |
1 rows × 25 columns
In [60]:
#Question 11(Rating History of Playstore over Years)
playstore['Released_New'] = pd.to_datetime(playstore['Released']).dt.date
playstore['Released_New']
Out[60]:
0 2020-02-26
1 2020-05-21
4 2020-02-21
5 2018-12-24
9 2019-09-22
...
2312933 2014-12-11
2312934 2020-06-15
2312938 2018-05-22
2312940 2018-01-17
2312942 2016-08-01
Name: Released_New, Length: 1287191, dtype: object
In [61]:
playstore['year'] = pd.DatetimeIndex(playstore['Released_New']).year
In [62]:
playstore.head()
Out[62]:
| App_Name | App_Id | Category | Rating | Rating_Count | Installs | Minimum_Installs | Maximum_Installs | Free | Price | ... | Last_Updated | Content_Rating | Privacy_Policy | Ad_Supported | In_App_Purchases | Editors_Choice | Scraped_Time | Released_New | Last_Updated_New | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Gakondo | com.ishakwe.gakondo | Adventure | 0.0 | 0.0 | 10+ | 10.0 | 15 | True | 0.0 | ... | Feb 26, 2020 | Everyone | https://beniyizibyose.tk/projects/ | False | False | False | 2021-06-15 20:19:35 | 2020-02-26 | 2020-02-26 | 2020 |
| 1 | Ampere Battery Info | com.webserveis.batteryinfo | Tools | 4.4 | 64.0 | 5,000+ | 5000.0 | 7662 | True | 0.0 | ... | May 06, 2021 | Everyone | https://dev4phones.wordpress.com/licencia-de-uso/ | True | False | False | 2021-06-15 20:19:35 | 2020-05-21 | 2021-05-06 | 2020 |
| 4 | GROW.me | com.horodyski.grower | Tools | 0.0 | 0.0 | 100+ | 100.0 | 478 | True | 0.0 | ... | Nov 12, 2018 | Everyone | http://www.horodyski.com.pl | False | False | False | 2021-06-15 20:19:35 | 2020-02-21 | 2018-11-12 | 2020 |
| 5 | IMOCCI | com.imocci | Social | 0.0 | 0.0 | 50+ | 50.0 | 89 | True | 0.0 | ... | Dec 20, 2019 | Teen | https://www.imocci.com/wp-content/uploads/2018... | False | True | False | 2021-06-15 20:19:35 | 2018-12-24 | 2019-12-20 | 2018 |
| 9 | Neon 3d Iron Tech Keyboard Theme | com.ikeyboard.theme.neon_3d.iron.tech | Personalization | 4.7 | 820.0 | 50,000+ | 50000.0 | 62433 | True | 0.0 | ... | Oct 07, 2020 | Everyone | http://bit.ly/EmojiThemePro | True | False | False | 2021-06-15 20:19:35 | 2019-09-22 | 2020-10-07 | 2019 |
5 rows × 27 columns
In [63]:
dm=playstore[['year','Rating']].value_counts()
In [64]:
pg=playstore.groupby(['year']).mean().Rating.reset_index()
pg
Out[64]:
| year | Rating | |
|---|---|---|
| 0 | 2010 | 3.764156 |
| 1 | 2011 | 3.671509 |
| 2 | 2012 | 3.568271 |
| 3 | 2013 | 3.420646 |
| 4 | 2014 | 3.310734 |
| 5 | 2015 | 3.056678 |
| 6 | 2016 | 2.754932 |
| 7 | 2017 | 2.512189 |
| 8 | 2018 | 2.282580 |
| 9 | 2019 | 2.001792 |
| 10 | 2020 | 1.949656 |
| 11 | 2021 | 1.434679 |
In [65]:
fig = px.line(pg, x="year", y="Rating", markers = True)
fig.show()
In [66]:
dm.groupby(level = 0)
Out[66]:
<pandas.core.groupby.generic.SeriesGroupBy object at 0x00000254AC4C7AC0>
In [67]:
dm
Out[67]:
year Rating
2020 0.0 153622
2019 0.0 136416
2018 0.0 90426
2017 0.0 61962
2021 0.0 47642
...
2011 1.3 2
2010 1.5 2
2011 1.1 2
2010 1.6 1
1.3 1
Length: 498, dtype: int64
Question 14¶
In [68]:
#Question 14 (Most Installed App within each category)
playstore.Category.value_counts()
Out[68]:
Education 127219 Business 100311 Music & Audio 87008 Lifestyle 75017 Tools 67215 Entertainment 63581 Books & Reference 56515 Health & Fitness 51770 Shopping 48981 Productivity 46960 Travel & Local 46613 Food & Drink 45773 Finance 44111 Personalization 37819 Communication 30703 News & Magazines 29320 Sports 29180 Social 27164 Puzzle 25069 Casual 21958 Medical 20260 Arcade 19925 Photography 16827 Maps & Navigation 15821 Educational 13048 Simulation 12569 Action 12385 Auto & Vehicles 10744 Adventure 10295 House & Home 8707 Events 8497 Art & Design 8007 Video Players & Editors 6883 Beauty 6179 Trivia 5885 Role Playing 5711 Racing 5383 Board 5175 Word 4989 Card 4858 Strategy 4117 Weather 4103 Dating 3429 Casino 2810 Parenting 2381 Libraries & Demo 2371 Music 2200 Comics 1345 Name: Category, dtype: int64
In [69]:
# app=playstore[['Category','App_Name']].reset_index().max()
# app
In [70]:
playstore[playstore.Category=='Education'].App_Name.max()
Out[70]:
'🧠 Smart - Brain fitness'
In [71]:
playstore[playstore.Category=='Business'].App_Name.max()
Out[71]:
'🤑Consultar Servicios Públicos Honduras🛠️🇭🇳Free'
In [131]:
ma=playstore[playstore.Category=='Music & Audio'].App_Name.max()
ma
Out[131]:
'\U000e0067\U000e0062\U000e0065\U000e006e\U000e0067\U000e007fRadio England 🏴\U000e0067\U000e0062\U000e0065\U000e006e\U000e0067\U000e007f📻'
In [141]:
playstore[playstore.Category=='Business'].App_Name.Installs.max()
Out[141]:
52 10+
58 100+
94 100+
100 10+
101 10+
...
2312883 100+
2312889 1+
2312914 10+
2312922 50+
2312926 500+
Name: Installs, Length: 100311, dtype: object
In [160]:
cai=playstore[['Category','App_Name','Installs']].value_counts()
cai
Out[160]:
Category App_Name Installs
Tools Flashlight 10+ 18
Card Solitaire 1,000,000+ 16
Health & Fitness BMI Calculator 1,000+ 14
Tools Flashlight 100+ 14
Puzzle Sudoku 1,000+ 13
..
Music & Audio رقية الحسد للشيخ ناصر القطامي 1,000+ 1
رقية الحسد للشيخ هاني الرفاعي 1,000+ 1
رقية الزواج لمن تعطل زواجها أو تأخر نصيبها-بدون نت 10,000+ 1
رقية الشرعية من الكتاب والسنة 1,000+ 1
Action "Emoji Run" casual game. 2020 Japan buzzword Emoji 100+ 1
Length: 1280394, dtype: int64
In [152]:
cai.groupby(level=[0,1]).sum()
Out[152]:
Category App_Name
Action "Emoji Run" casual game. 2020 Japan buzzword Emoji 1
"Turn-Based" Chaos 1
# storm Area 51 1
'Roid Runner 1
( ͡° ͜ʖ ͡°) PugWars 1
..
Word 💚Word Sauce: Free Word Connect Puzzle 1
📱 Sopa de Letras Infinitas 📱 1
🔥Kitty Scramble: Word Stacks 1
😎 Угадай слово по смайликам 1
🟢Crocword: Crossword Puzzle Game 1
Length: 1260765, dtype: int64
In [153]:
cai
Out[153]:
Category App_Name Installs
Tools Flashlight 10+ 18
Card Solitaire 1,000,000+ 16
Health & Fitness BMI Calculator 1,000+ 14
Tools Flashlight 100+ 14
Puzzle Sudoku 1,000+ 13
..
Music & Audio رقية الحسد للشيخ ناصر القطامي 1,000+ 1
رقية الحسد للشيخ هاني الرفاعي 1,000+ 1
رقية الزواج لمن تعطل زواجها أو تأخر نصيبها-بدون نت 10,000+ 1
رقية الشرعية من الكتاب والسنة 1,000+ 1
Action "Emoji Run" casual game. 2020 Japan buzzword Emoji 100+ 1
Length: 1280394, dtype: int64
In [73]:
playstore[playstore.Category=='Lifestyle '].App_Name.max()
Out[73]:
nan
In [74]:
playstore[playstore.Category=='Tools'].App_Name.max()
Out[74]:
'🧲 Magnetometer Magnetic Sensor Metal Detector'
In [75]:
playstore[playstore.Category=='Entertainment'].App_Name.max()
Out[75]:
'🧴 Desinfectante casero'
In [76]:
playstore[playstore.Category=='Books & Reference '].App_Name.max()
Out[76]:
nan
In [77]:
playstore[playstore.Category=='Health & Fitness'].App_Name.max()
Out[77]:
'🥥107 Way Uses & Health Benefit for Coconut Oil🥥'
In [78]:
playstore[playstore.Category=='Shopping'].App_Name.max()
Out[78]:
'🔥Half Price: Coles, Woolworths'
In [79]:
playstore[playstore.Category=='Productivity '].App_Name.max()
Out[79]:
nan
In [80]:
playstore[playstore.Category=='Travel & Local'].App_Name.max()
Out[80]:
'🛰️ Vex - GPS Tracker'
In [81]:
playstore[playstore.Category=='Food & Drink'].App_Name.max()
Out[81]:
'🥩 Recetas de Vaca Gratis 🥩'
In [82]:
playstore[playstore.Category=='Finance '].App_Name.max()
Out[82]:
nan
In [83]:
playstore[playstore.Category=='Personalization'].App_Name.max()
Out[83]:
'🦾Best Superhero wallpaper and Lock screen HD'
In [84]:
playstore[playstore.Category=='Communication '].App_Name.max()
Out[84]:
nan
In [85]:
playstore[playstore.Category=='News & Magazines'].App_Name.max()
Out[85]:
'📰Новости АВТО: тест-драйвы, обзоры, новинки'
In [86]:
playstore[playstore.Category=='Sports'].App_Name.max()
Out[86]:
'🤸 Aerobics, routines of aerobic exercises 🧘\u200d♀️'
In [87]:
playstore[playstore.Category=='Social'].App_Name.max()
Out[87]:
'🙏Recibe la Paz de lo Alto😀Mi Paz os Doy👍Ten FE'
In [88]:
playstore[playstore.Category=='Puzzle'].App_Name.max()
Out[88]:
'🥇 Cube Puzzle 3D 🥇'
In [89]:
playstore[playstore.Category=='Casual'].App_Name.max()
Out[89]:
'🧜\u200d♀️👸Mermaid Makeup Salon'
In [90]:
playstore[playstore.Category=='Medical'].App_Name.max()
Out[90]:
'🐕 Home Remedies For Dogs 🐕'
In [91]:
playstore[playstore.Category=='Arcade'].App_Name.max()
Out[91]:
'🧱 Breaking Bad Bricks 😎'
In [92]:
playstore[playstore.Category=='Photography'].App_Name.max()
Out[92]:
'🦁 Lion Wallpaper : Wild King Backgrounds'
In [93]:
playstore[playstore.Category=='Maps & Navigation'].App_Name.max()
Out[93]:
'🚦Bangalore Traffic Fine/Challan Checker'
In [94]:
playstore[playstore.Category=='Educational'].App_Name.max()
Out[94]:
"🧹🧽Mom's Sweet Helper - House Spring Cleaning"
In [95]:
playstore[playstore.Category=='Simulation'].App_Name.max()
Out[95]:
'🧜\u200d♀️Mermaid Princess Makeup & Dress Up Girls Game'
In [96]:
playstore[playstore.Category=='Action'].App_Name.max()
Out[96]:
'🧟Zombie Ops 3D shooter - sniper undead revenants'
In [97]:
playstore[playstore.Category=='Auto & Vehicles'].App_Name.max()
Out[97]:
'🛵 Scooter Modification App'
In [98]:
playstore[playstore.Category=='Adventure'].App_Name.max()
Out[98]:
'🧨Heroes of Match 3'
In [99]:
playstore[playstore.Category=='House & Home'].App_Name.max()
Out[99]:
'🕯️Candle light: MEDITATION🤔, RELAX😌 and SLEEP😴'
In [100]:
playstore[playstore.Category=='Events'].App_Name.max()
Out[100]:
'🎵 Aishwa Nahla - Marhaban Yaa Ramadhan'
In [101]:
playstore[playstore.Category=='Art & Design'].App_Name.max()
Out[101]:
'🦄 Rainbow Unicorn Glitter Wallpaper 4K [UHD]'
In [102]:
playstore[playstore.Category=='Video Players & Editors'].App_Name.max()
Out[102]:
'📷 Video To Photo Converter'
In [103]:
playstore[playstore.Category=='Beauty'].App_Name.max()
Out[103]:
'📻 Rádio 105 FM (Jundiaí - SP)'
In [104]:
playstore[playstore.Category=='Trivia'].App_Name.max()
Out[104]:
'🛸 UFO Quiz 2020 🛸'
In [105]:
playstore[playstore.Category=='Role Playing'].App_Name.max()
Out[105]:
'🧚 Fairy Princess Makeup Dress Up Girls Game'
In [106]:
playstore[playstore.Category=='Racing'].App_Name.max()
Out[106]:
'🚗🏁UAZ 4x4: Dirt Offroad Rally Racing Simulator'
In [107]:
playstore[playstore.Category=='Board'].App_Name.max()
Out[107]:
'🐍 Snakes and Ladders Board Games 🎲'
In [108]:
playstore[playstore.Category=='Word'].App_Name.max()
Out[108]:
'🟢Crocword: Crossword Puzzle Game'
In [109]:
playstore[playstore.Category=='Card'].App_Name.max()
Out[109]:
'🎴 Hanafuda Koi-Koi Ramen (Free)'
In [110]:
playstore[playstore.Category=='Strategy'].App_Name.max()
Out[110]:
'🔫 Toy Commander: Army Men Battles'
In [111]:
playstore[playstore.Category=='Weather'].App_Name.max()
Out[111]:
'🌕 Leuksna - Moon calendar & moon phases'
In [112]:
playstore[playstore.Category=='Dating'].App_Name.max()
Out[112]:
'😍 La La Chat - Meet New Friends and Free Dating'
In [113]:
playstore[playstore.Category=='Casino'].App_Name.max()
Out[113]:
'💰 Spinner Slots 🎰 Fidget Fun Casino 💎'
In [114]:
playstore[playstore.Category=='Parenting '].App_Name.max()
Out[114]:
nan
In [115]:
playstore[playstore.Category=='Libraries & Demo'].App_Name.max()
Out[115]:
'👷\u200d DUARIB 🕹️🛠️'
In [116]:
playstore[playstore.Category=='Music'].App_Name.max()
Out[116]:
'😱 Undertale Deltarune songs - Piano tiles offline'
In [117]:
playstore[playstore.Category=='Comics'].App_Name.max()
Out[117]:
'할리퀸만화 – 미스터블루가 엄선한 할리퀸웹툰, 무료만화'
Question 10¶
In [118]:
#Question 10 (Smallest & Largest App size on the store)
playstore.columns
Out[118]:
Index(['App_Name', 'App_Id', 'Category', 'Rating', 'Rating_Count', 'Installs',
'Minimum_Installs', 'Maximum_Installs', 'Free', 'Price', 'Currency',
'Size', 'Minimum_Android', 'Developer_Id', 'Developer_Website',
'Developer_Email', 'Released', 'Last_Updated', 'Content_Rating',
'Privacy_Policy', 'Ad_Supported', 'In_App_Purchases', 'Editors_Choice',
'Scraped_Time', 'Released_New', 'Last_Updated_New', 'year'],
dtype='object')
In [119]:
playstore.Size.max()
Out[119]:
'Varies with device'
In [120]:
playstore.Size.min()
Out[120]:
'1,000k'
In [121]:
playstore.Size.unique()
Out[121]:
array(['10M', '2.9M', '6.2M', ..., '314M', '512M', '405M'], dtype=object)
In [161]:
# sel_chng_type = list(set(['Size']))
# sel_chng_type
br=type(playstore.Size[0])
br
Out[161]:
str
In [180]:
size=pd.Series([playstore.Size])
size
Out[180]:
0 0 10M 1 2.9M 4 6.2... dtype: object
In [ ]: